import openpyxl

myBook=openpyxl.load_workbook('员工表.xlsx')
mySheet=myBook.active

myValues=list(mySheet.values)[1:]
mySet=set(myValues)
while mySheet.max_row>1:
	mySheet.delete_rows(2)

for myRow in mySet:
	mySheet.append(myRow)

myBook.save('结果表-员工表.xlsx')
